<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `fanwe_youhui`;");
E_C("CREATE TABLE `fanwe_youhui` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `deal_cate_id` int(11) NOT NULL,
  `begin_time` int(11) NOT NULL,
  `end_time` int(11) NOT NULL,
  `city_id` int(11) NOT NULL,
  `send_type` tinyint(1) NOT NULL COMMENT '0:普通券 1:验证券 2:需预订验证券',
  `sms_count` int(11) NOT NULL,
  `print_count` int(11) NOT NULL,
  `view_count` int(11) NOT NULL,
  `sort` int(11) NOT NULL,
  `is_effect` tinyint(1) NOT NULL,
  `sms_content` varchar(255) NOT NULL,
  `is_sms` tinyint(1) NOT NULL,
  `is_print` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否打印:1不允许;0:允许',
  `brief` text NOT NULL COMMENT '简介',
  `youhui_type` tinyint(1) NOT NULL COMMENT '减免0/折扣1',
  `deal_cate_match_row` text NOT NULL,
  `deal_cate_match` text NOT NULL,
  `locate_match_row` text NOT NULL,
  `locate_match` text NOT NULL,
  `name_match_row` text NOT NULL,
  `name_match` text NOT NULL,
  `xpoint` varchar(255) NOT NULL,
  `ypoint` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT '用户发布的',
  `supplier_id` int(11) NOT NULL COMMENT '商户',
  `create_time` int(11) NOT NULL,
  `brand_id` int(11) NOT NULL,
  `pub_by` tinyint(1) NOT NULL COMMENT '0:管理员 1:会员 2:商家',
  `is_recommend` tinyint(1) NOT NULL,
  `list_brief` text NOT NULL,
  `description` text NOT NULL,
  `index_img` varchar(255) NOT NULL,
  `image_3` varchar(255) NOT NULL,
  `image_3_w` int(11) NOT NULL,
  `image_3_h` int(11) NOT NULL,
  `address` varchar(255) NOT NULL,
  `publish_wait` tinyint(1) NOT NULL,
  `return_money` double(11,4) NOT NULL,
  `return_score` int(11) NOT NULL,
  `return_point` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `city_id` (`city_id`),
  KEY `cate_id` (`deal_cate_id`) USING BTREE,
  FULLTEXT KEY `f_t` (`deal_cate_match`,`name_match`,`locate_match`),
  FULLTEXT KEY `cate_match` (`deal_cate_match`),
  FULLTEXT KEY `name_match` (`name_match`),
  FULLTEXT KEY `locate_match` (`locate_match`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8");
E_D("replace into `fanwe_youhui` values('1','[牡丹大酒楼]菜金满100元送','./public/attachment/201303/04/22/5134ad25c54a1.jpg','./public/attachment/201303/04/22/5134ad1e311d0.jpg','0','0','0','1','0','0','0','0','1','1','','0','0','','0','','','全国','ux20840ux22269','菜金,酒楼,牡丹,100,[牡丹大酒楼]菜金满100元送','ux33756ux37329,ux37202ux27004,ux29281ux20025,ux49ux48ux48,ux91ux29281ux20025ux22823ux37202ux27004ux93ux33756ux37329ux28385ux49ux48ux48ux20803ux36865','','','0','0','1362377906','0','0','1','','本程序由盛世源码社区<a href=\"http://www.9upp.com|vip.9upp.com|www.9upp.com\">www.9upp.com|vip.9upp.com|www.9upp.com</a>提供,更多极品商业源码,就在盛世源码社区vip服务:vip.9upp.com<br />','','','0','0','','0','0.0000','0','0');");
E_D("replace into `fanwe_youhui` values('2','肯德基多款超值优惠券打印','./public/attachment/201303/05/00/5134c9645b21b.jpg','http://dc.fanwe.com/public/attachment/201212/25/16/50d96aca367d4.jpg','0','0','0','1','0','0','0','0','2','1','','0','0','','0','','','全国','ux20840ux22269','肯德,基多,优惠券,超值,打印,肯德基多款超值优惠券打印','ux32943ux24503,ux22522ux22810,ux20248ux24800ux21048,ux36229ux20540,ux25171ux21360,ux32943ux24503ux22522ux22810ux27454ux36229ux20540ux20248ux24800ux21048ux25171ux21360','','','0','0','1362385150','0','0','1','','<center><div style=\"line-height:21px;\">资源提供：<a href=\"http://www.9upp.com/\" target=\"_blank\"><font color=\"red\">盛世源码社区</font></a> <br />\r\n&nbsp; <a href=\"http://www.9upp.com/\" target=\"_blank\">盛世源码社区</a> | <a href=\"http://vip.9upp.com/\" target=\"_blank\">极品商业源码</a> | <a href=\"http://idc.9upp.com/\" target=\"_blank\">盛世源码社区空间、域名</a> | <a href=\"http://vip.9upp.com/templates/Korea/\" target=\"_blank\">90G韩国豪华商业模版</a> | <a href=\"http://tool.9upp.com/\" target=\"_blank\">站长工具箱</a> <br />\r\n更多精品商业资源，就在<a href=\"http://www.9upp.com/\" target=\"_blank\">盛世源码社区</a></font> </div>\r\n</center>','','','0','0','','0','0.0000','0','0');");
E_D("replace into `fanwe_youhui` values('3','必胜客消费第一季 特惠午餐','./public/attachment/201303/05/00/5134c992481b4.jpg','http://dc.fanwe.com/public/attachment/201212/25/17/50d96c90944b7.jpg','0','0','0','1','0','0','0','1','3','1','','0','0','','0','','','全国','ux20840ux22269','必胜客,特惠,午餐,消费,必胜客消费第一季 特惠午餐','ux24517ux32988ux23458,ux29305ux24800,ux21320ux39184,ux28040ux36153,ux24517ux32988ux23458ux28040ux36153ux31532ux19968ux23395ux29305ux24800ux21320ux39184','','','0','0','1362385190','0','0','1','','<center><div style=\"line-height:21px;\">资源提供：<a href=\"http://www.9upp.com/\" target=\"_blank\"><font color=\"red\">盛世源码社区</font></a><br />\r\n&nbsp;<a href=\"http://www.9upp.com/\" target=\"_blank\">盛世源码社区</a> | <a href=\"http://vip.9upp.com/\" target=\"_blank\">极品商业源码</a> | <a href=\"http://idc.9upp.com/\" target=\"_blank\">盛世源码社区空间、域名</a> | <a href=\"http://vip.9upp.com/templates/Korea/\" target=\"_blank\">90G韩国豪华商业模版</a> | <a href=\"http://tool.9upp.com/\" target=\"_blank\">站长工具箱</a><br />\r\n更多精品商业资源，就在<a href=\"http://www.9upp.com/\" target=\"_blank\">盛世源码社区</a></font></div>\r\n</center>','','','0','0','','0','0.0000','0','0');");

require("../../inc/footer.php");
?>